Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_CLUSTERS

`ALL_CLUSTERS` describes all clusters accessible to the current user.

Related Views

- `DBA_CLUSTERS` describes all clusters in the database.

- `USER_CLUSTERS` describes all clusters owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the cluster
`CLUSTER_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the cluster
`TABLESPACE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the tablespace containing the cluster
`PCT_FREE` | `NUMBER` |  | Minimum percentage of free space in a block
`PCT_USED` | `NUMBER` |  | Minimum percentage of used space in a block
`KEY_SIZE` | `NUMBER` |  | Estimated size of cluster key plus associated rows
`INI_TRANS` | `NUMBER` | `NOT NULL` | Initial number of transactions
`MAX_TRANS` | `NUMBER` | `NOT NULL` | Maximum number of transactions
`INITIAL_EXTENT` | `NUMBER` |  | Size of the initial extent in bytes
`NEXT_EXTENT` | `NUMBER` |  | Size of secondary extents in bytes
`MIN_EXTENTS` | `NUMBER` | `NOT NULL` | Minimum number of extents allowed in the segment
`MAX_EXTENTS` | `NUMBER` | `NOT NULL` | Maximum number of extents allowed in the segment
`PCT_INCREASE` | `NUMBER` |  | Percentage increase in extent size
`FREELISTS` | `NUMBER` |  | Number of process freelists allocated to this segment
`FREELIST_GROUPS` | `NUMBER` |  | Number of freelist groups allocated to this segment
`AVG_BLOCKS_PER_KEY` | `NUMBER` |  | Number of blocks in the table divided by number of cluster keys
`CLUSTER_TYPE` | `VARCHAR2(5)` |  | Type of cluster: B*-Tree index or hash
`FUNCTION` | `VARCHAR2(15)` |  | If a hash cluster, the hash function
`HASHKEYS` | `NUMBER` |  | If a hash cluster, the number of hash keys (hash buckets)
`DEGREE` | `VARCHAR2(10)` |  | Number of threads per instance for scanning the cluster
`INSTANCES` | `VARCHAR2(10)` |  | Number of instances across which the cluster is to be scanned
`CACHE` | `VARCHAR2(5)` |  | Indicates whether the cluster is to be cached in the buffer cache (`Y`) or not (`N`)
`BUFFER_POOL` | `VARCHAR2(7)` |  | Default buffer pool for the cluster
`SINGLE_TABLE` | `VARCHAR2(5)` |  | Indicates whether this is a single-table cluster (`Y`) or not (`N`)
`DEPENDENCIES` | `VARCHAR2(8)` |  | Indicates whether row-level dependency tracking is enabled (`ENABLED`) or disabled (`DISABLED`)